CREATE TABLE [dbo].[DataTypeCalc]
(
[sFromTypeCode] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[sTypeCode1] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[sTypeCode2] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[sMathOperation] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataTypeCalc] ADD CONSTRAINT [PK__DataType__7AEDE5EF4F7CD00D] PRIMARY KEY CLUSTERED  ([sFromTypeCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataTypeCalc] ADD CONSTRAINT [FK__DataTypeC__sMath__5165187F] FOREIGN KEY ([sFromTypeCode]) REFERENCES [dbo].[DataType] ([sTypeCode])
GO
ALTER TABLE [dbo].[DataTypeCalc] ADD CONSTRAINT [FK__DataTypeC__sType__52593CB8] FOREIGN KEY ([sTypeCode1]) REFERENCES [dbo].[DataType] ([sTypeCode])
GO
ALTER TABLE [dbo].[DataTypeCalc] ADD CONSTRAINT [FK__DataTypeC__sType__534D60F1] FOREIGN KEY ([sTypeCode2]) REFERENCES [dbo].[DataType] ([sTypeCode])
GO
